CREATE TABLE student ( student_id int NOT NULL AUTO_INCREMENT, name varchar(255) NOT NULL, year varchar(20), test int, PRIMARY KEY (student_id) ); insert into student (name,year,test) values ("Joe Jones","Senior",85);